https://gibs.com RSS feeds for Global Internet Business Solutions ~ GIBS 60 https://gibs.com/Support/Knowledge-Base/ID/331/nopCommerce_SQL_Query_for_Top_10_Gross_Sales_Days#Comments 0 https://gibs.com/DesktopModules/DnnForge%20-%20NewsArticles/RssComments.aspx?TabID=51&ModuleID=411&ArticleID=331 https://gibs.com:443/DesktopModules/DnnForge%20-%20NewsArticles/Tracking/Trackback.aspx?ArticleID=331&PortalID=0&TabID=51 https://gibs.com/Support/Knowledge-Base/ID/331/nopCommerce_SQL_Query_for_Top_10_Gross_Sales_Days Declare @current_utc_offset int IF  ServerProperty('EngineEdition') >= 5 Begin set @current_utc_offset = (select  convert(int, left(current_utc_offset,3)) AS current_utc_offset from sys.time_zone_info Where Name = 'US Eastern Standard Time') End PRINT @current_utc_offset SELECT TOP 10 SUM([OrderTotal]) as totalSales, Count([Id]) AS Orders,  dateadd(hour, @current_utc_offset, dateadd(hour, datediff(hour, 0, convert(date, [CreatedOnUtc])), 0)) FROM [dbo].[Order] GROUP BY dateadd(hour, @current_utc_offset, dateadd(hour, datediff(hour, 0, convert(date, [CreatedOnUtc])), 0)) ORDER BY SUM([OrderTotal]) desc Webmaster Tue, 04 Feb 2025 15:26:00 GMT f1397696-738c-4295-afcd-943feb885714:331 https://gibs.com/Support/Knowledge-Base/ID/332/nopCommerce_SQL_Query_for_Top_10_Sales_Days#Comments 0 https://gibs.com/DesktopModules/DnnForge%20-%20NewsArticles/RssComments.aspx?TabID=51&ModuleID=411&ArticleID=332 https://gibs.com:443/DesktopModules/DnnForge%20-%20NewsArticles/Tracking/Trackback.aspx?ArticleID=332&PortalID=0&TabID=51 https://gibs.com/Support/Knowledge-Base/ID/332/nopCommerce_SQL_Query_for_Top_10_Sales_Days Declare @current_utc_offset int IF  ServerProperty('EngineEdition') >= 5 Begin set @current_utc_offset = (select  convert(int, left(current_utc_offset,3)) AS current_utc_offset from sys.time_zone_info Where Name = 'US Eastern Standard Time') End PRINT @current_utc_offset SELECT TOP 10 SUM([OrderTotal]) as totalSales, Count([Id]) AS Orders,  dateadd(hour, @current_utc_offset, dateadd(hour, datediff(hour, 0, convert(date, [CreatedOnUtc])), 0)) FROM [dbo].[Order] GROUP BY dateadd(hour, @current_utc_offset, dateadd(hour, datediff(hour, 0, convert(date, [CreatedOnUtc])), 0)) ORDER BY SUM([OrderTotal]) desc Webmaster Tue, 04 Feb 2025 15:26:00 GMT f1397696-738c-4295-afcd-943feb885714:332 https://gibs.com/Support/Knowledge-Base/ID/328/nopCommerce_-_Deleting_Guest_Accounts#Comments 0 https://gibs.com/DesktopModules/DnnForge%20-%20NewsArticles/RssComments.aspx?TabID=51&ModuleID=411&ArticleID=328 https://gibs.com:443/DesktopModules/DnnForge%20-%20NewsArticles/Tracking/Trackback.aspx?ArticleID=328&PortalID=0&TabID=51 https://gibs.com/Support/Knowledge-Base/ID/328/nopCommerce_-_Deleting_Guest_Accounts Deleting guest account from Customer table: SQL Query DELETE Customer FROM Customer LEFT OUTER JOIN [Order] ON Customer.Id = [Order].CustomerId WHERE ([Order].Id IS NULL) AND (Customer.Email IS NULL) delete guest account - nopCommerce Webmaster Sun, 12 Jan 2025 10:01:00 GMT f1397696-738c-4295-afcd-943feb885714:328